Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_FILE_GROUP_TABLESPACES

`ALL_FILE_GROUP_TABLESPACES` shows information about the transportable tablespaces present (partially or completely) in the file groups accessible to the current user (when the file groups contain dump files).

Related Views

- `DBA_FILE_GROUP_TABLESPACES` shows information about the transportable tablespaces present (partially or completely) in all file groups in the database (when the file groups contain dump files).

- `USER_FILE_GROUP_TABLESPACES` shows information about the transportable tablespaces present (partially or completely) in the file groups owned by the current user (when the file groups contain dump files). This view does not display the `FILE_GROUP_OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`FILE_GROUP_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the file group
`FILE_GROUP_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the file group
`VERSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Version of the file group that contains the tablespace
`VERSION` | `NUMBER` | `NOT NULL` | Internal version number
`TABLESPACE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the tablespace